Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemLabelID (PK) | A unique system assigned identifier for the ItemLabel. | ID_LB_ITM | Identity | integer | |
LanguageID (FK) | A combination of ISO-639-1 and ISO-3661-1 to denote a lanuage as spoken in a particular country. | ID_LGE | Code4External | char(4) | Language(CO_LGE) |
EquipmentID (FK) | The fixed asset number assigned by the retailer for this particular piece of equipment. | ID_EQ | Identity | integer | Equipment(AS_EQ) |
BusinessUnitGroupID (FK) | A unique system assigned identifier for a group of BusinessUnits. | ID_BSNGP | Identity | integer | BusinessUnitGroupItem(AS_BSNGP_ITM) |
ItemID (FK) | A unique system assigned identifier for the retailer's SKU being labelled. | ID_ITM | IdentityUUID | char(32) | BusinessUnitGroupItem(AS_BSNGP_ITM) |
EffectiveDateTime (FK) | The date from which the BusinessUnits in the group carry the Item being labelled. | TS_EF | EffectiveDateTime | datetime | BusinessUnitGroupItem(AS_BSNGP_ITM) |
TypeCode | Identifies the type of label to be created. | TY_LB | Code2 | char(2) | |